/*
 Navicat Premium Data Transfer

 Source Server         : LocalHost
 Source Server Type    : SQL Server
 Source Server Version : 15002080
 Source Host           : LocalHost:1433
 Source Catalog        : wiUniGUI
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 15002080
 File Encoding         : 65001

 Date: 28/05/2021 09:10:45
*/


-- ----------------------------
-- Table structure for tblFunction
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFunction]') AND type IN ('U'))
	DROP TABLE [dbo].[tblFunction]
GO

CREATE TABLE [dbo].[tblFunction] (
  [fldFunctionCode] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldMainMenuCode] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldParentCode] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NULL,
  [fldKeyFieldName] varchar(50) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFunctionName1] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFunctionName2] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFunctionName3] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldUserName1] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldUserName2] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldUserName3] nvarchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldNeedApproval] bit DEFAULT 0 NOT NULL,
  [fldNeedPopedomControl] bit DEFAULT 1 NOT NULL,
  [fldIsAFunction] bit DEFAULT 0 NOT NULL,
  [fldSendMessage] bit DEFAULT 0 NOT NULL,
  [fldType] varchar(1) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldModuleType] varchar(2) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldApprovalTypeCode] varchar(30) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldEffectiveFromDate] datetime  NOT NULL,
  [fldEffectiveToDate] datetime  NOT NULL,
  [fldHaveEffectiveToDate] bit DEFAULT 0 NOT NULL,
  [fldUserReferControl] bit DEFAULT 0 NOT NULL,
  [fldReportFileName] varchar(100) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldCreator] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldCreateTime] datetime DEFAULT getdate() NOT NULL,
  [fldLastModifier] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldLastModTime] datetime DEFAULT getdate() NOT NULL,
  [fldNoOfMod] int DEFAULT 1 NOT NULL
)
GO

ALTER TABLE [dbo].[tblFunction] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblFunction
-- ----------------------------
INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'01', N'11', N'', N'', N'Manufacturing Management', N'生产管理', N'生產管理', N'Manufacturing Management', N'生产管理', N'生產管理', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-24 08:43:32.760', N'2')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flManufactureDashboard', N'11001', N'11', N'', N'Manufacture Dashboard', N'生产看板', N'生產看板', N'Manufacture Dashboard', N'生产看板', N'生產看板', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-26 22:18:52.937', N'7')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flOperationDispatch', N'11002', N'11', N'', N'Operation Dispatch', N'生产任务', N'生產任務', N'Operation Dispatch', N'生产任务', N'生產任務', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-26 22:18:52.937', N'5')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flProcessReporting', N'11003', N'11', N'', N'Process Reporting', N'工序报工', N'工序報工', N'Process Reporting', N'工序报工', N'工序報工', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-26 22:20:03.130', N'6')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flHourRegister', N'11004', N'11', N'', N'Hour Register', N'工时登记', N'工時登記', N'Hour Register', N'工时登记', N'工時登記', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-26 22:20:03.130', N'6')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'02', N'12', N'', N'', N'Enquiry', N'质量管理', N'質量管理', N'Enquiry', N'质量管理', N'質量管理', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-24 09:06:28.663', N'2')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'03', N'13', N'', N'', N'Maintenance', N'仓储物流', N'仓储物流', N'Maintenance', N'仓储物流', N'仓储物流', N'0', N'1', N'0', N'0', N'0', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'03001', N'13001', N'13', N'', N'System Information Maintenance', N'系统资料维护', N'系統資料維護', N'System Information Maintenance', N'系统资料维护', N'系統資料維護', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'03002', N'13002', N'13', N'', N'User Information Maintenance', N'用户资料维护', N'用戶資料維護', N'User Information Maintenance', N'用户资料维护', N'用戶資料維護', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'03012', N'13012', N'13', N'', N'Approval Information Maintenance', N'审批资料维护', N'審批資料維護', N'Approval Information Maintenance', N'审批资料维护', N'審批資料維護', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'04', N'14', N'', N'', N'Reports / Listings', N'设备管理', N'设备管理', N'Reports / Listings', N'设备管理', N'设备管理', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'04001', N'14001', N'14', N'', N'Master List', N'主要列表', N'主要列表', N'Master List', N'主要列表', N'主要列表', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'04002', N'14002', N'14', N'', N'Audit Trail', N'审核记录', N'審核記錄', N'Audit Trail', N'审核记录', N'審核記錄', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'04003', N'14003', N'14', N'', N'Status / Analysis', N'状况 / 分析列表', N'狀況 / 分析列表', N'Status / Analysis', N'状况 / 分析列表', N'狀況 / 分析列表', N'0', N'1', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'rlReportWriter', N'14004', N'14', N'', N'Report Writer', N'报表生成器', N'報表生成器', N'Report Writer', N'报表生成器', N'報表生成器', N'0', N'1', N'1', N'0', N'R', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'06', N'16', N'', N'', N'System Managemant', N'系统管理', N'參數', N'System Managemant', N'系统管理', N'參數', N'0', N'0', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-24 07:24:31.910', N'2')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flChangeSystemDate', N'16001', N'16', N'', N'Change System Date', N'更改系统日期', N'更改系統日期', N'Change System Date', N'更改系统日期', N'更改系統日期', N'0', N'1', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'06002', N'16002', N'16', N'', N'Language', N'', N'語言', N'Language', N'语言', N'語言', N'0', N'0', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SUPERVISOR', N'2021-05-24 07:24:31.910', N'2')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'ssLanguage1', N'1600201', N'16002', N'', N'English', N'English', N'English', N'English', N'English', N'English', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'ssLanguage2', N'1600202', N'16002', N'', N'中文(简体)', N'中文(简体)', N'中文(简体)', N'中文(简体)', N'中文(简体)', N'中文(简体)', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'ssLanguage3', N'1600203', N'16002', N'', N'中文(繁体)', N'中文(繁体)', N'中文(繁體)', N'中文(繁體)', N'中文(繁體)', N'中文(繁體)', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flChangePassword', N'16003', N'16', N'', N'Change Password', N'更改密码', N'更改密碼', N'Change Password', N'更改密码', N'更改密碼', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flSystemMenu', N'16005', N'16', N'', N'SystemMenu', N'系统菜单', N'系统菜单', N'SystemMenu', N'系统菜单', N'系统菜单', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'07', N'17', N'', N'', N'Exit', N'退出', N'退出', N'Exit', N'离开', N'離開', N'0', N'0', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flLogin', N'17001', N'17', N'', N'Login', N'重新登录', N'重新登錄', N'Login', N'重新登录', N'重新登錄', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'ssClose', N'17002', N'17', N'', N'Close System', N'关闭系统', N'關閉系統', N'Close System', N'关闭系统', N'關閉系統', N'0', N'0', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'08', N'18', N'', N'', N'Help', N'帮助', N'幫助', N'Help', N'帮助', N'幫助', N'0', N'0', N'0', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO

INSERT INTO [dbo].[tblFunction] ([fldFunctionCode], [fldMainMenuCode], [fldParentCode], [fldKeyFieldName], [fldFunctionName1], [fldFunctionName2], [fldFunctionName3], [fldUserName1], [fldUserName2], [fldUserName3], [fldNeedApproval], [fldNeedPopedomControl], [fldIsAFunction], [fldSendMessage], [fldType], [fldModuleType], [fldApprovalTypeCode], [fldEffectiveFromDate], [fldEffectiveToDate], [fldHaveEffectiveToDate], [fldUserReferControl], [fldReportFileName], [fldCreator], [fldCreateTime], [fldLastModifier], [fldLastModTime], [fldNoOfMod]) VALUES (N'flAbout', N'18001', N'18', N'', N'About', N'关于', N'關於', N'About', N'关于', N'關於', N'0', N'1', N'1', N'0', N'', N'C', N'', N'1900-01-01 00:00:00.000', N'1900-01-01 00:00:00.000', N'0', N'0', N'', N'SYSTEM', N'2003-05-01 00:00:00.000', N'SYSTEM', N'2003-05-01 00:00:00.000', N'1')
GO


-- ----------------------------
-- Table structure for tblFunctionList
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFunctionList]') AND type IN ('U'))
	DROP TABLE [dbo].[tblFunctionList]
GO

CREATE TABLE [dbo].[tblFunctionList] (
  [fldFunctionCode] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldFormClassName] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldPackageName] varchar(200) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL
)
GO

ALTER TABLE [dbo].[tblFunctionList] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblFunctionList
-- ----------------------------
INSERT INTO [dbo].[tblFunctionList] ([fldFunctionCode], [fldFormClassName], [fldPackageName]) VALUES (N'flHourRegister', N'TfrHourRegister', N'FC\HourRegister')
GO

INSERT INTO [dbo].[tblFunctionList] ([fldFunctionCode], [fldFormClassName], [fldPackageName]) VALUES (N'flManufactureDashboard', N'TfrManufactureDashboard', N'FC\ManufactureDashboard')
GO

INSERT INTO [dbo].[tblFunctionList] ([fldFunctionCode], [fldFormClassName], [fldPackageName]) VALUES (N'flOperationDispatch', N'TfrOperationDispatch', N'FC\OperationDispatch')
GO

INSERT INTO [dbo].[tblFunctionList] ([fldFunctionCode], [fldFormClassName], [fldPackageName]) VALUES (N'flProcessReporting', N'TfrProcessReporting', N'FC\ProcessReporting')
GO

INSERT INTO [dbo].[tblFunctionList] ([fldFunctionCode], [fldFormClassName], [fldPackageName]) VALUES (N'flSystemMenu', N'TfrEapMenuTree', N'EAP\SystemMenu')
GO


-- ----------------------------
-- Table structure for tblFunctionMessageFormatDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFunctionMessageFormatDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblFunctionMessageFormatDetails]
GO

CREATE TABLE [dbo].[tblFunctionMessageFormatDetails] (
  [fldFunctionCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldMessagePartCode] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldFormatString] nvarchar(1000) COLLATE Chinese_PRC_CI_AS DEFAULT '' NOT NULL,
  [fldFormatString1] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [fldFormatString2] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [fldFormatString3] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [fldFormatString4] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [fldFormatString5] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[tblFunctionMessageFormatDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblFunctionMessageFormatDetails
-- ----------------------------
INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flGoodsTransfer', N'mpBody', N'发件人:%s您好:转仓单编号:%s出库库位:%s入库库位:%s数量:%s		%s		%s', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flGoodsTransfer', N'mpSubject', N'转仓单:', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flManufacturingOrder', N'mpBody', N'发件人:%s您好:领料单待审：(%s)领料生产单号:%s		%s		%s', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flManufacturingOrder', N'mpSubject', N'生产领料:', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flSalesChange', N'mpBody', N'发件人:%s您好:销售变更单号:%s销售订单:%s新增衣服:%s修改衣服:%s取消衣服:%s		%s		%s', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flSalesChange', N'mpSubject', N'销售变更:', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flWorkOverAgainRequisition', N'mpBody', N'发件人:%s您好:改衫申请单号:%s改衫申请内容%s待审生产处理单:%s待审退料单:%s待审转仓单:%s		%s		%s', NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[tblFunctionMessageFormatDetails] ([fldFunctionCode], [fldMessagePartCode], [fldFormatString], [fldFormatString1], [fldFormatString2], [fldFormatString3], [fldFormatString4], [fldFormatString5]) VALUES (N'flWorkOverAgainRequisition', N'mpSubject', N'改衫申请:', NULL, NULL, NULL, NULL, NULL)
GO


-- ----------------------------
-- Table structure for tblFunctionRecipientsDetails
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFunctionRecipientsDetails]') AND type IN ('U'))
	DROP TABLE [dbo].[tblFunctionRecipientsDetails]
GO

CREATE TABLE [dbo].[tblFunctionRecipientsDetails] (
  [fldFunctionCode] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldRecipientsAddress] nvarchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[tblFunctionRecipientsDetails] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblFunctionRecipientsDetails
-- ----------------------------
INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'comp22@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'comp3@oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'mySale1@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'Ocfashion01@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'OcSales02@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'product1@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'Product3@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'rosette@Oceanfur.com')
GO

INSERT INTO [dbo].[tblFunctionRecipientsDetails] ([fldFunctionCode], [fldRecipientsAddress]) VALUES (N'flSalesChange', N'william@Oceanfur.com')
GO


-- ----------------------------
-- Table structure for tblFunctionTable
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[tblFunctionTable]') AND type IN ('U'))
	DROP TABLE [dbo].[tblFunctionTable]
GO

CREATE TABLE [dbo].[tblFunctionTable] (
  [fldFunctionCode] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldTableName] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [fldMaster] bit DEFAULT 0 NOT NULL
)
GO

ALTER TABLE [dbo].[tblFunctionTable] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of tblFunctionTable
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tblFunction
-- ----------------------------
ALTER TABLE [dbo].[tblFunction] ADD CONSTRAINT [PK_tblFunction] PRIMARY KEY CLUSTERED ([fldMainMenuCode], [fldFunctionCode])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblFunctionList
-- ----------------------------
ALTER TABLE [dbo].[tblFunctionList] ADD CONSTRAINT [PK_tblFunctionList] PRIMARY KEY CLUSTERED ([fldFunctionCode], [fldFormClassName])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblFunctionMessageFormatDetails
-- ----------------------------
ALTER TABLE [dbo].[tblFunctionMessageFormatDetails] ADD CONSTRAINT [PK_tblFunctionMessageBodyFormatDetails] PRIMARY KEY CLUSTERED ([fldFunctionCode], [fldMessagePartCode])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblFunctionRecipientsDetails
-- ----------------------------
ALTER TABLE [dbo].[tblFunctionRecipientsDetails] ADD CONSTRAINT [PK_tblFunctionRecipientsDetails] PRIMARY KEY CLUSTERED ([fldFunctionCode], [fldRecipientsAddress])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table tblFunctionTable
-- ----------------------------
ALTER TABLE [dbo].[tblFunctionTable] ADD CONSTRAINT [PK_tblFunctionTable] PRIMARY KEY CLUSTERED ([fldFunctionCode], [fldTableName])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

